SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_SearchRecruitmentByundertakingsideStudent]
	(
	@param_undertakingside NVarChar(50)
	)
AS
	/* SET NOCOUNT ON */
	Select * from dbo.JOL_Recruitment where undertakingside like '%'+@param_undertakingside+'%' AND state='True'
	 ORDER BY update_time,add_time DESC

	RETURN
GO
